CREATE TABLE [dbo].[ONE_WMS] (
[BillId] varchar(30) COLLATE Chinese_PRC_CI_AS NOT NULL DEFAULT '' ,
[syncbillid] varchar(30) COLLATE Chinese_PRC_CI_AS NOT NULL DEFAULT '' ,
[billdate] char(10) COLLATE Chinese_PRC_CI_AS NOT NULL DEFAULT '' ,
[QTYIN] int NOT NULL DEFAULT ((0)) ,
PRIMARY KEY ([BillId])
)
ON [PRIMARY]
GO
INSERT INTO ('BillId','syncbillid','billdate','QTYIN') ONE_WMS values('"+ext +"','"+pass +'")